-- UAP报表脚本(数量: 1张 生成时间:2019年11月10日 10:19)
-- 1.单据数目对照表( 1个视图,项目号U8CUSTDEF)
-- "单据数目对照表"
-- 添加新的UAP报表
-- 插入项目信息
DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF'
INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/11/10 10:17:23',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
GO
-- UAP报表数据报表级基础信息
DELETE FROM UAP_Report WHERE ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'',N'174df926-9cdb-42db-83e8-557dbc929bbd',N'Function1',N'',N'U8CUSTDEF',N'SA',N'',N'',N'1',N'0',N'demo',N'2019/11/10 10:16:19',N'1',N'',N'',N'',N'1',NULL,NULL,N'1',NULL,N'0',NULL)
GO
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'en-US'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'en-US',N'单据数目对照表',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'zh-CN'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'zh-CN',N'单据数目对照表',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' AND LocaleID=N'zh-TW'
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'zh-TW',N'单据数目对照表',NULL,N'0')
GO
DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'6c420594-068c-4023-b76b-056729798c1b')
GO
-- UAP报表数据源:可能包含进行扩展后的BO对象
DELETE FROM BD_BusinessObjects WHERE MetaID=N'174df926-9cdb-42db-83e8-557dbc929bbd'
INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'174df926-9cdb-42db-83e8-557dbc929bbd',N'test(2019-11-10 上午 10:19:45)',N'U8CUSTDEF',N'SA',N'',N'test',N'ReportBO',N'',N'0')
GO
-- UAP报表过滤条件
-- UAP报表添加新的视图
-- UAP报表视图级基础信息
DELETE FROM UAP_ReportView WHERE ID=N'6c420594-068c-4023-b76b-056729798c1b'
INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'A4@#$0',N'0',NULL,N'80,80,80,80',N'9',N'0',NULL,N'',N'40',N'1',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
GO
DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'en-US'
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'en-US',N'单据数目对照表',NULL)
DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-CN'
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'zh-CN',N'单据数目对照表',N'1')
DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-TW'
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'zh-TW',N'单据数目对照表',NULL)
GO
-- UAP报表视图的格式信息
UPDATE UAP_ReportView SET ID=N'6c420594-068c-4023-b76b-056729798c1b',Format=N'',RuntimeFormat=N'',Chartstring=N'' WHERE ID=N'6c420594-068c-4023-b76b-056729798c1b'
GO
UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'en-US',Format=N'' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'en-US'
UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'zh-CN',Format=N'' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-CN'
UPDATE UAP_ReportView_Lang SET ViewID=N'6c420594-068c-4023-b76b-056729798c1b',LocaleID=N'zh-TW',Format=N'' WHERE ViewID=N'6c420594-068c-4023-b76b-056729798c1b' AND LocaleID=N'zh-TW'
GO
-- 备份的原始视图格式
-- 颜色字体方案
-- 功能权限
DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'6c420594-068c-4023-b76b-056729798c1b'
INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'_6c420594-068c-4023-b76b-056729798c1b',N'1')
GO
-- 视图的字段权限
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143731' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143731',NULL,N'1',N'GetCopritionName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143733' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143733',NULL,N'1',N'GetUserName()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143735' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143735',NULL,N'1',N'Date()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143737' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143737',NULL,N'1',N'page()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'Drawing143739' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'Drawing143739',NULL,N'1',N'pages()',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'单据类型' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'单据类型',NULL,N'1',N'单据类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'截止时间' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'截止时间',NULL,N'1',N'截止时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'开始时间' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'开始时间',NULL,N'1',N'开始时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'en-US'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'zh-CN'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
DELETE FROM AA_ColumnDic_Base WHERE cKey=N'6c420594-068c-4023-b76b-056729798c1b' AND cFld=N'下载总数' AND LocaleID=N'zh-TW'
INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'6c420594-068c-4023-b76b-056729798c1b',N'下载总数',NULL,N'1',N'下载总数',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
GO
-- 门户菜单相关
-- 联查功能
-- 报表自定义事件